using Baci.Net.ToolKit.ArcGISProGeoprocessor.Models;
using Baci.Net.ToolKit.ArcGISProGeoprocessor.Models.Attributes;
using Baci.Net.ToolKit.ArcGISProGeoprocessor.Models.Attributes.DomainAttributes;
using Baci.Net.ToolKit.ArcGISProGeoprocessor.Models.Enums;
using System.Collections.Generic;
using System.ComponentModel;

namespace Baci.ArcGIS._DataManagementTools._GeodatabaseAdministration
{
    /// <summary>
    /// <para>Delete Database Sequence</para>
    /// <para>Deletes a database sequence from a geodatabase.</para>
    /// <para>从地理数据库中删除数据库序列。</para>
    /// </summary>    
    [DisplayName("Delete Database Sequence")]
    public class DeleteDatabaseSequence : AbstractGPProcess
    {
        /// <summary>
        /// 无参构造
        /// </summary>
        public DeleteDatabaseSequence()
        {

        }

        /// <summary>
        /// 有参构造
        /// </summary>
        /// <param name="_in_workspace">
        /// <para>Input Workspace</para>
        /// <para><xdoc>
        ///   <para>The full path to the location of the file geodatabase from which you want to delete a sequence or the database connection file (.sde) to connect to the enterprise geodatabase from which you want to delete a sequence. The user specified in the database connection must have the following permissions in the database:
        ///   <bulletList>
        ///     <bullet_item>Db2—DBADM authority  </bullet_item><para/>
        ///     <bullet_item>Oracle—Must be the sequence owner or have the DROP ANY SEQUENCE system privilege  </bullet_item><para/>
        ///     <bullet_item>PostgreSQL—Must be the sequence owner  </bullet_item><para/>
        ///     <bullet_item>SAP HANA—Must be a standard user  </bullet_item><para/>
        ///     <bullet_item>SQL Server—ALTER OR CONTROL permission on the database schema where the sequence is stored  </bullet_item><para/>
        ///   </bulletList>
        ///   </para>
        /// </xdoc></para>
        /// <para><xdoc>
        /// <para>要从中删除序列的文件地理数据库或数据库连接文件 （.sde） 的完整路径，用于连接到要从中删除序列的企业级地理数据库。在数据库连接中指定的用户必须在数据库中具有以下权限：
        ///   <bulletList>
        ///     <bullet_item>Db2 - DBADM 权限</bullet_item><para/>
        ///     <bullet_item>Oracle - 必须是序列所有者或具有 DROP ANY SEQUENCE 系统权限</bullet_item><para/>
        ///     <bullet_item>PostgreSQL - 必须是序列所有者</bullet_item><para/>
        ///     <bullet_item>SAP HANA - 必须是标准用户</bullet_item><para/>
        ///     <bullet_item>SQL Server - 对存储序列的数据库架构的 ALTER OR CONTROL 权限</bullet_item><para/>
        ///   </bulletList>
        ///   </para>
        /// </xdoc></para>
        /// </param>
        /// <param name="_seq_name">
        /// <para>Sequence Name</para>
        /// <para>The name of the database sequence you want to delete. Once deleted, the sequence cannot be used to generate sequence IDs when called from existing custom applications or expressions.</para>
        /// <para>要删除的数据库序列的名称。删除后，从现有自定义应用程序或表达式调用序列时，该序列将无法用于生成序列 ID。</para>
        /// </param>
        public DeleteDatabaseSequence(object _in_workspace, object _seq_name)
        {
            this._in_workspace = _in_workspace;
            this._seq_name = _seq_name;
        }
        public override string ToolboxName => "Data Management Tools";

        public override string ToolName => "Delete Database Sequence";

        public override string CallName => "management.DeleteDatabaseSequence";

        public override List<string> AcceptEnvironments => ["workspace"];

        public override object[] ParameterInfo => [_in_workspace, _seq_name, _out_workspace];

        /// <summary>
        /// <para>Input Workspace</para>
        /// <para><xdoc>
        ///   <para>The full path to the location of the file geodatabase from which you want to delete a sequence or the database connection file (.sde) to connect to the enterprise geodatabase from which you want to delete a sequence. The user specified in the database connection must have the following permissions in the database:
        ///   <bulletList>
        ///     <bullet_item>Db2—DBADM authority  </bullet_item><para/>
        ///     <bullet_item>Oracle—Must be the sequence owner or have the DROP ANY SEQUENCE system privilege  </bullet_item><para/>
        ///     <bullet_item>PostgreSQL—Must be the sequence owner  </bullet_item><para/>
        ///     <bullet_item>SAP HANA—Must be a standard user  </bullet_item><para/>
        ///     <bullet_item>SQL Server—ALTER OR CONTROL permission on the database schema where the sequence is stored  </bullet_item><para/>
        ///   </bulletList>
        ///   </para>
        /// </xdoc></para>
        /// <para><xdoc>
        /// <para>要从中删除序列的文件地理数据库或数据库连接文件 （.sde） 的完整路径，用于连接到要从中删除序列的企业级地理数据库。在数据库连接中指定的用户必须在数据库中具有以下权限：
        ///   <bulletList>
        ///     <bullet_item>Db2 - DBADM 权限</bullet_item><para/>
        ///     <bullet_item>Oracle - 必须是序列所有者或具有 DROP ANY SEQUENCE 系统权限</bullet_item><para/>
        ///     <bullet_item>PostgreSQL - 必须是序列所有者</bullet_item><para/>
        ///     <bullet_item>SAP HANA - 必须是标准用户</bullet_item><para/>
        ///     <bullet_item>SQL Server - 对存储序列的数据库架构的 ALTER OR CONTROL 权限</bullet_item><para/>
        ///   </bulletList>
        ///   </para>
        /// </xdoc></para>
        /// <para></para>
        /// </summary>
        [DisplayName("Input Workspace")]
        [Description("")]
        [Option(OptionTypeEnum.Must)]
        public object _in_workspace { get; set; }


        /// <summary>
        /// <para>Sequence Name</para>
        /// <para>The name of the database sequence you want to delete. Once deleted, the sequence cannot be used to generate sequence IDs when called from existing custom applications or expressions.</para>
        /// <para>要删除的数据库序列的名称。删除后，从现有自定义应用程序或表达式调用序列时，该序列将无法用于生成序列 ID。</para>
        /// <para></para>
        /// </summary>
        [DisplayName("Sequence Name")]
        [Description("")]
        [Option(OptionTypeEnum.Must)]
        public object _seq_name { get; set; }


        /// <summary>
        /// <para>Deleted sequence from geodatabase</para>
        /// <para></para>
        /// <para></para>
        /// <para></para>
        /// </summary>
        [DisplayName("Deleted sequence from geodatabase")]
        [Description("")]
        [Option(OptionTypeEnum.derived)]
        public object _out_workspace { get; set; }


        public DeleteDatabaseSequence SetEnv(object workspace = null)
        {
            base.SetEnv(workspace: workspace);
            return this;
        }

    }

}